DATETAB.MDB                                                October 1995

for Microsoft Access database Ver 1.1,2.0,2.5

Brief description:

This MDB file can be used for the following:

Select any MDB via Win API to add date info to the "@DateTable" Table 
in the DATETAB.MDB or print the existing "@DateTable" table.  
The Access code will read though each table in the selected MDB to obtain the 
table information. This will show the last table modification or update time, 
creation date and size of tables and no. of records contained in that 
selected MDB or previous selected MDB's. The data will be placed in 
table "@DateTable" where it can be viewed or printed.

This table can maintain this info for multiple MDB's. The access basic code
can be modified to show time changes for macros, modules etc.

 Handy for debugging.
 "Did I really change something here in this table, code or form ?"
 "When did a transaction take place in this table"

This access basic code also shows how to create a internal MDB table
with your own field sizes and types and then delete it on request.
 Handy for debugging internal basic code. 

This access basic code also demos some access to "sstable"
           (internal MDB system tables SysTable)



Notes: 

  - Not checked for network errors.

  - You will probably have to reset printer setup on report
       to suit your printer.

  - Must be from an admin group to run but can change open database
    code module. 

  - Ensure SHARE is active. Or try to see what happens.

  - This can be setup to display dates for macros and modules etc but
    security provisions beyond ver 1.1 may invalidate the method
    available. Does run under Ver 2.0

  - Attached MDB tables have an indication of a null # of records
    

  - You may have duplicate module names so change accordingly.

  - If "@DateTable" table does not exist it is created. 

  - To view MDB without autostart feature hold down CTRL + Shift Key 
    when opening MDB.

  - May be some extraneous modules contained in here that are no longer
    used or were just for testing.

  _ Could use this for a really "ruff" and basic version control.

  - To obtain fresh date and time table just select delete and rebuild.


Use abuse and modify code to your hearts content. This code is not
idiot proof and has incomplete error checking. So beware accordingly!.


If I get enough response, I'll modify for Macros, Modules, Forms etc.

  Marty Connelly  ai603@carleton.freenet.ca
  Marty Connelly  ua218@freenet.victoria.bc.ca
      1195 Stonington Pl. Victoria, BC Canada V8X 3B8